SELECT T.* ,
T_DICTIONARY_TYPE.code AS typeCode,
T_DICTIONARY_TYPE.name AS typeName
FROM C1_DICTIONARY T
LEFT JOIN C1_DICTIONARY_TYPE T_DICTIONARY_TYPE
ON (Sysdate BETWEEN T_DICTIONARY_TYPE.begin_date AND T_DICTIONARY_TYPE.end_date
AND T_DICTIONARY_TYPE.ID = t.type_id)
WHERE T.ID = :id